Tabela LPatientAddress

Definicja tabeli LPatientAddress

Name

LPatientAddress

Code

LPatientAddress

Comment

 


Lista kolumn tabeli LPatientAddress

Name

Code

AddressID

AddressID

PatientID

PatientID

StartDT

StartDT

StopDT

StopDT


Kolumna AddressID tabeli LPatientAddress

Definicja kolumny AddressID tabeli LPatientAddress

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli LPatientAddress

Definicja kolumny PatientID tabeli LPatientAddress

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LPatientAddress

Definicja kolumny StartDT tabeli LPatientAddress

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli LPatientAddress

Definicja kolumny StopDT tabeli LPatientAddress

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Lista kluczy tabeli LPatientAddress

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPatientAddress

Definicja klucza Identifier_1 tabeli LPatientAddress

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment